Chip 2000 June/CHIPCD_6_2000.iso/software/sharewar/filemake/data1.cab/Examples/ODBC_Example/Sales Reports.fp5

FileMaker Pro Database | 2000-02-01 | 156KB | 1,145 lines

 work makAll play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All
HBAM2016AUG95
Pro 5.0
 All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a goodCopyright 1984-1997 Claris Corporation
 and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy.
HBAM3016AUG95@
filemakerA
filemaker
sp-12341234
keithA
keith
proctorA
proctorA
berryA
berryA
central
:ODBC
    ODBC Demo
"SELECT Sales_Data.Invoice_ID, Sales_Data.Company_Name, Sales_Data.Date_Sold, Sales_Data.Amount, Sales_Data.Salesperson_ID, Salespeople.Salesperson, Salespeople.Sales_Manager, Salespeople.Sales_Region
FROM Sales_Data, Salespeople
WHERE Sales_Data.Salesperson_ID = Salespeople.Salesperson_ID
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
    ODBC Demo
"SELECT Sales_Data.Invoice_ID, Sales_Data.Company_Name, Sales_Data.Date_Sold, Sales_Data.Amount, Sales_Data.Salesperson_ID, Salespeople.Salesperson, Salespeople.Sales_Manager, Salespeople.Sales_Region
FROM Sales_Data, Salespeople
WHERE Sales_Data.Salesperson_ID = Salespeople.Salesperson_ID
COMPANY NAME
G    DATE SOLD
INVOICE ID
SALES MANAGER
A    Form View
A    List View
by Date
Information
Report Menu
by Company
by Salesperson
by Sales Region
ODBC Import
A    Form ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
SALES REGION
SALESPERSON
SALESPERSON ID
THEERROR
TOTAL AMOUNT
WEEK NUMBER
Invoice IDB
A    Date SoldB
Company NameB
InfoB
Salesperson IDB
SalespersonB
Sales ManagerB
Sales RegionB
Week NumberB
Total AmountB
YearB
theErrorB
Description
This database is designed to work with the sample ODBC data in the ODBC Example folder. Use this file to retrieve data from:
    Salespeople
    Sales_Data
The Salespeople table has information for seven employees, such as their names, their managers' names, their sales regions, and their employee identification numbers.
The Sales_Data table has 250 records tracking sales that the employees have made.
Refer to the "Using ODBC with FileMaker Pro" section of the User's Guide fo
Equipment, Inc.",
  "Audio Supplies Company",
  "Ice Cream, Inc.",
  "Furniture Manufacturing Company",
  "Home Furniture Suppliers",
  "Furniture International",
  "Office Equipment, Inc.",
  "Language Institute",
  "New Technology University",
  "Data Systems Instutute",
  "Office Supply, Inc.",
  "Office Supply International",
  "Office Equipment International",
  "Exports, S.A."
Amount = Round (2000 + ( 1 + Round(Random* (3000 - 1), 0)) + TextToNum("." & ( 1 + Round(Random* (99 - 1E
), 0))), 2)
Yesfter
Noarter
Salesperson
Sales Manager
Sales Region
Sales Data
Your Own
Button
Import
Records
Record
Delete
Record
Record
Reports
View As
View As
Close
Salesperson Data
Invoice ID
Enter data for Sales Reports
Company Name
Amount
{    Date Sold
Salesperson ID
Salesperson
Sales Manager
Sales Region
Sales Data
by DateB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Import
Records
Reports
View As
View As
Close
CONFIDENTIAL
Page ##
Printed on //, ::
Sales By Company
TOTAL
Grand Total:
COMPANY
by SalespersonB
by SalespersonB
InformationB
Report MenuB
Import
Records
Reports
View As
View As
Close
CONFIDENTIAL
Page ##
Printed on //, ::
Sales By Date
TOTAL_
Import
Records
Reports
View As
View As
Close
CONFIDENTIAL
Page ##
Printed on //, ::
Sales By Date
TOTAL
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoN
O+Information about the Sales Reports exampleP
Info for this example
Import
Records
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoN
O+Information about the Sales Reports exampleP
Info for this example
Import
Records
Amount\
Company Name]
Your Own
Button`
Recorda
Delete
Recordb
Recordc
Reportsd
View As
Liste
View As
Formf
Closeg
Infoh0Click to see more information for a Sales Report
Salespersonp
Sales Managerr
Sales Regions
Import
Records
OKgion
Cancel
Some or all records have been found to have empty Sales Region data.  This report may be invalid.
by Sales RegionB
by SalespersonC
by CompanyD
 by DateF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoL
Select a reportR
Import
RecordsS$Click a button to preview the report
by Sales RegionB
by SalesersonC
by CompanyD
 by DateF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoL
Select a reportR
Import
RecordsS$Click a button to preview the report
OKue`
Prohibit modif
Cancel of value`
Your report has been canceled because there aren't any records in the found set.
ReportsC
View As
ListD
View As
FormE
CloseF
InfoG
Import
Records
by CompanyB
by CompanyB
Import
Records
Reports
View As
View As
Close
CONFIDENTIAL
Page ##
Printed on //, ::
Sales By Salesperson
TOTAL
Grand Total:
SALESPERSON
by Sales RegionB
by Sales RegionB
COMPANY
Grand Total:
WEEK #
A    List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Import
Records
Reports
View As
View As
Close
CONFIDENTIAL
Page ##
Printed on //, ::
Sales By Sales Region
TOTAL
Grand Total:
SALES REGION
SALESPERSON
Yesfter
Noarter
Salesperson
Sales Manager
Sales Region
Sales Data
SALES REGION
ntral
N    282197.27
eastern
N    160700.87
western
N    443245.31
sonia
susan
kenwood
timothy
murphy
N    886143.45
0657.92
nancy
cohen
N    179258.95
sonia
N    102938.32
susan
kenwood
N    222587.39
timothy
murphy
N    160700.87
Import
RecordsG
View As
Import
RecordsG
View As
Import
RecordsB
ReportsC
View As
ListD
View As
FormE
CloseF
ODBC ImportB
ODBC ImportB
1234X
7/8/98
Filemaker Inc.
SP-12341234
Keith Proctor
[    Pam Berry
Central
3/27/98
Canadian Export Company
3435.91
Jennifer Norris
Bill Swanson
Western
1/20/98
New Technology University
2996.48
Nancy Cohen
Dennis Nguyen
Central
6/6/98
Photo Supply, Inc.
3741.22
Jennifer Norris
Bill Swanson
Western
3/3/98
Photo Supply, Inc.
4503.19
Timothy Murphy
Julie Chen
Eastern
2/27/98
New Technology University
4496.11
Susan Kenwood
Bill Swanson
Western
4/14/98
New Technology University
2275.74
Timothy Murphy
Julie Chen
Eastern
4/26/98
Exports, Inc.
4224.2
Timothy Murphy
Julie Chen
Eastern
4/24/98
ReyMont University
2290.16
Susan Kenwood
Bill Swanson
Western
1/3/98t, Inc.
View As
FormI
CloseJ
InfoKQFor information on ODBC Import, refer to the Installation and New Features Guide.L
Select an importN
Delete all RecordsO
ODBC Sales DataP
ODBC Sales Data & PeopleQ    Walk-ThruR
Reports
furniture
manufacturing
company@
ational@
supplies
companyJ
bakeryj
canadianB
canadian
export
companyB
coffee_
coffee
companm
companyB
computerW
computer
systems
corporationL
creamk
data[
systems
instutute[
easternm
eastern
photo
technology
companm
equipmentO
everywhere
everywhere
travel
exportB
exportsH
exports
exports
internationalK
exports
furnitureA
furniture
internationalR
furniture
manufacturing
companyT
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Report by Date
Sort by Sales Person
Startup Script
Find...
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.
Delete all records
Sort by Sales Region
Report Completed
 "Person")
PersonGB
OKgion
Cancel
Some or all records have been found to have empty Salesperson data.  This report may be invalid.D7
 "Region")
RegionGE
Report by Company
Report by Salesperson
Report by Sales Region
Import Sales Data
    ODBC Demo
nSELECT Sales_Data.Invoice_ID, Sales_Data.Company_Name, Sales_Data.Date_Sold, Sales_Data.Amount
FROM Sales_Data
") = 8    "W
") = 8    "W
Import Salespeople
:ODBC
    ODBC Demo
"SELECT Sales_Data.Invoice_ID, Sales_Data.Company_Name, Sales_Data.Date_Sold, Sales_Data.Amount, Sales_Data.Salesperson_ID, Salespeople.Salesperson, Salespeople.Sales_Manager, Salespeople.Sales_Region
FROM Sales_Data, Salespeople
WHERE Sales_Data.Salesperson_ID = Salespeople.Salesperson_ID
") = 8    "W
Report Started
) = 0
Import Completed
Paste
Clear
Cancell
Fields
Set Field
Paste
Literal
Paste Result
Paste fromODBC import completed.
Import Walk-Thru
ADODBC
    ODBC Demo
,SELECT Sales_Data.Invoice_ID
FROM Sales_Data
Clear
Cancell
Fields
Set Field
Paste
Literal
Paste Result
Paste fromODBC import completed.
Import Walk-Thru
    ODBC Demo
,SELECT Sales_Data.Invoice_ID
FROM Sales_Data
 Sales_People.Sales_Person_ID
Paste
Clear
Cancell
Fields
Set Field
Paste
Literal
Paste Result
Paste fromODBC import completed.
Import Walk-Thru
Import Error
Cancele
eThere was an ODBC error during Import.  The import was canceled.
SALES REGION
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
(LIST
LISTA
Western
Central
Eastern
VDEFA(
(LIST
VDEFA(
RegionB
Sales Manager
FMRLA
ODBC Example
FMRLA
ODBC Example
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
    ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
"%UR
UD33D
AD@D@
AD@D@
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
44444
CCCCC 44444 CCCCC
$42"
bRBBP0
@@BA@
UUUUU
(*)(%,3&
)%+@6)
",30,)%
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
company@
computer
systems
corporation@
export@
home@
institute@
photo
supply
suppliers@
university@
sp-7@
jennifer
norris
kenwood@
murphy@
sonia@
sonia
susan@
swanson@
chen@
dennis
dennis
nguyen@
nguyen@
swanson@
western@
supply
reymont
university@
sp-2@
sp-6@
jennifer@
jennifer
norris@
kenwood@
long@
nancy
cohen@
sonia@
sonia
long@
susan
kenwood@
timothy@
swanson@
chen@
dennis
nguyen@
julie
chen@
swanson@
eastern@
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%Q
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFG
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
g9o{o{w
NsNs!
g9o{w
g9o{w
F1NsV
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g
9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9F1o{
NsF1V
g9F11
o{o{g9g9^
)J)J!
)J)J!
)J)J!
)J)J!
)J)J!
)J)J!
)J)J!
NsF1F1
F1Ns!
)J)J1
)J)J1
)J)J1
)J)J1
)J)J1
)J)J1
)J)J1
)J)J1
DDDDDD
B"#B0
B"#B"$
"2#B"#B"#@
2$""#B"#@
"2#B"#@
2$B"#@
Pro 2.0 - 2.1F!
Pro 5.0N
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
    8/18/1999
AMOUNT
COMPANY NAME
G    DATE SOLD
INVOICE ID
SALES MANAGER
central
eastern
central
eastern
HP DeskJet 540 Printer
corporation@
technology@
university@
sp-2@
sp-6@
jennifer@
jennifer
norris@
kenwood@
long@
nancy@
nancy
cohen@
norris@
sonia@
sonia
long@
susan
kenwood@
timothy@
swanson@
chen@
dennis@
dennis
nguyen@
julie@
julie
chen@
nguyen@
swanson@
eastern@
Startup Script
Sort by Date
Sort by Company
Sort by Sales Person
Sort by Sales Region
Find...
Report Started
Report by Date
Report by Company
Report by Salesperson
Report by Sales Region
Report Completed
Import Walk-Thru
Import Sales Data
Import Salespeople
Import Completed
Import Error
Delete all records
Sort by Date
Sort by CompanySort by Company
ata and Salespeople tables, joining on the Salesperson_ID column
Create custom reports by modifying the Sales Reports database fields, layouts, and scripts.
r instructions on how to import data from both tables using ODBC drivers. You can also import the sample ODBC data using scripts provided in this database. Click the Import Records button, then choose one of the following buttons:
 Delete all Records
 Walk Thru, which steps you through the ODBC import feature once you've configured the ODBC driver
 ODBC Sales Data, which automatically imports data from the Sales_Data table
 ODBC Sales Data and People, which automatically imports dC
ata from the Sales_Data and Salespeople tables, joining on the Salesperson_ID column
Create custom reports by modifying the Sales Reports database fields, layouts, and scripts.
AmountB
InfoB
Salesperson IDB
SalespersonB
Sales ManagerB
Sales RegionB
Week NumberB
Total AmountB
YearB